The records are not ones desired due to query retrieves wrong records.
Cause:
In the Query Design view, use the 'Fields' row of the query grid to add field name or replace existing field name with correct field names.
Solution:
In the Query Design view, use the 'Fields' row of the query grid to add field name or replace existing field name with correct field names.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query in the list box. (The selected query is highlighted.)
4) Click 'Design'. (The query appears in Design view.)
5) Click in the desired 'Fields' cell of the query grid. (A down arrow appears.)
6) Click down arrow. (A drop-down list appears.)
7) Select the desired field name from the 'Fields' drop-down list.
8) Repeat steps 5) through 7) for each additional field.
9) Select the 'File' menu and select 'Save' to save changes to the query.
10) Select the 'Query' menu and select 'Run' to view the results of the query.
